CREATE PROCEDURE [KS_ProGetProFromCart] 
@userName nvarchar(50)
AS
select top 100 C.*,i.amount,i.channelid,i.classid,i.turnurl,i.filename,i.title,i.DefaultPic,i.groupprice,i.attributecart,i.price as price_market,i.price_member,i.taxtf,i.tax,i.Score,I.IsLimitBuy,I.LimitBuyPrice,I.LimitBuyAmount,i.IsScoreChange,I.ChangeScore FROM [KS_ProShoppingCart] C Inner Join [KS_ProductList] I ON C.InfoID=I.InfoID Where C.Flag=0 and C.UserName=@userName order by C.isChangeBuy ,C.IsBundleSale,C.CartID